﻿create table [mem].[kvValues]
(
	[KeyId] bigint not null,
	[SortOrder] bigint identity not null,
	[Part] varbinary(8000) not null

	-- 16MB overhead, expecting avg of 16 parts ~128kb
	-- this is needed only for data durability. The roomy hash bucket sizing facilitates 
	-- SQL XTP GC
	constraint [mem_kvValues_PK] primary key nonclustered ([KeyId],[SortOrder]) 

) with (MEMORY_OPTIMIZED = ON, DURABILITY=SCHEMA_AND_DATA)